-------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  \\micro.intra\Projekt\P0624$\P0624_Gem\Politisk Geografi\Results\log\merge.log
  log type:  text
 opened on:   2 Oct 2023, 16:38:38

. 
. set type double 

. use "$dat\dist p_id year.dta", clear

. joinby p_id year using "$dat\lisa_togeo.dta", unmatched(master)

. drop _merge

. 
. gen valar = year

. 
. joinby p_id valar using "$dat\mun politician data", unmatched(both) 

.         
. 
.         
. 
. keep p_id- dist inv1g_ejn  inv1g_eje valar vald parti_initial  age inc educ_year child*

.         *bef=befolkning i distriktet adbef=vuxenbefolkning
.         gen bef=1 if dist!=.
(379,243 missing values generated)

.         gen adbef = 1 if inc!=.
(882,945 missing values generated)

.         
.         bysort p_id :egen fy_vald=min (valar) if vald==1
(22,023,853 missing values generated)

.         gen vald_first= valar ==fy_vald

.         drop if valar<2000
(325,562 observations deleted)

. gen parti_low=lower(parti_initial)
(21,623,107 missing values generated)

. 
. ***partier: b=sd m=moderatern c=centern k=kd f=liberalerna g=MP  s=social:demokraterna v=vansterpartiet
. 
. *generarar variabel för antalt nominerade och valda från varje parti
. foreach parti in b m c k f l g s v{
  2. gen vald_`parti'= vald==1 & parti_low =="`parti'"
  3.  }

. 
.  
. gen vald_right= vald==1 & ( parti_low =="c"| parti_low =="m" |parti_low =="k"  | parti_low =="f")

. gen vald_left= vald==1 & (parti_low =="s"| parti_low =="g" |parti_low =="v")

.  fasterxtile pct=inc , by(year) n(100)

. gen retired=age>=65

. gen highq= pct>75 & pct!=.

. gen highed=educ_year>13

.  gen em=1-inv1g_eje 
(557,874 missing values generated)

. 
.  
. 
.  collapse (sum) bef adbef vald* high*  em child* retired , by (llkk dist year)

.         drop if llkk==.
(1 observation deleted)

.         drop if dist==9999
(0 observations deleted)

.         drop if adbef==.
(0 observations deleted)

.         replace bef=bef+child_7_15 // children not included in calculation
(17,425 real changes made)

. 
. sort llkk dist year

. 
.         
. joinby dist llkk  year using "$dat\dist_election.dta" , unmatched(master)

. drop _merge

. 
. 
. joinby dist llkk year using "$dat\prices_precinct_ep.dta", unmatched(master) _merge(_mergeprice)

. replace electionperiod= year if electionperiod==.
(1,080 real changes made)

. g ln_price_sqm_old=ln(price_sqm_old)
(1,139 missing values generated)

. 
. joinby llkk electionperiod using "$dat\mun competition.dta", unmatched(master)

. drop _merge             

. 
. joinby llkk valar using "$dat\kommundata.dta", unmatched(master)

. drop _merge

. 
. 
.  
.         foreach gr in vald {
  2.  gen `gr'_maj =mmaj2*`gr'_m +  cmaj2*`gr'_c +  fpmaj2*`gr'_f + kdmaj2*`gr'_k + mpmaj2*`gr'_g + smaj2*`gr'_s + vmaj2*`gr'_v
  3.  gen `gr'_min=(`gr'_right+`gr'_left)-`gr'_maj
  4.  }
(756 missing values generated)
(756 missing values generated)

. 
. gen votes_right =rostmm + rostmc + rostmk+ rostmf

. gen votes_left =rostms + rostmv + rostmg

. 
. gen votes_maj =mmaj2*rostmm +  cmaj2*rostmc +  fpmaj2*rostmf + kdmaj2*rostmk + mpmaj2*rostmg + smaj2*rostms + vmaj2*rostmv
(756 missing values generated)

. gen votes_min =(1-mmaj2)*rostmm +  (1-cmaj2)*rostmc +  (1-fpmaj2)*rostmf + (1-kdmaj2)*rostmk + (1-mpmaj2)*rostmg + (1-smaj2)*rostms
>  + (1-vmaj2)*rostmv
(756 missing values generated)

. 
. gen votes =rostm_gil

. gen non_votes= adbef-votes

. 
. 
. joinby dist llkk  year using "$dat\permits.dta" , unmatched(master)

. drop _merge

. joinby llkk dist year using "$dat\tenure_precinct_ep.dta", unmatched(master) _merge(_merge)

. drop _merge

. gen own= owning_house+ owning_coop
(800 missing values generated)

. 
. 
. joinby dist llkk year using "$dat\property.dta", unmatched(master) _merge(_mergefast)

. 
. egen b_area_res= rowtotal(b_area_single b_area_chain b_area_two b_area_multi)

.                 
. joinby dist year llkk using "$dat\coll_neighbours.dta"  , unmatched(master)     

. drop _merge                             

. joinby dist year llkk using "$dat\timesame_neighbours.dta"      , unmatched(master)     

. drop _merge                             

. joinby dist year llkk using "$dat\relatives_neighbours" , unmatched(master)

. drop _merge

. 
. egen llkk_year=group(llkk year)

. 
. 
.  
. *** calculate share of group living in districts ***
. 
. foreach var of varlist non_votes votes bef adbef  highed em  child_7_15 retired highq  votes_left votes_right   ///
> area_single area_multi area_single_lag area_multi_lag vald- vald_left vald_maj vald_min votes_maj votes_min   b_area_single b_area_
> multi  b_multi b_single  pop own {
  2.         bysort llkk year (dist):  egen kom_`var' =sum(`var')
  3.         * calculate share of group living in the district
.         gen sh_`var' =`var' /kom_`var' 
  4.         }
(135 missing values generated)
(2,941 missing values generated)
(198 missing values generated)
(3,574 missing values generated)
(8,109 missing values generated)
(46 missing values generated)
(2,222 missing values generated)
(674 missing values generated)
(241 missing values generated)
(8,802 missing values generated)
(1,354 missing values generated)
(728 missing values generated)
(1,586 missing values generated)
(812 missing values generated)
(1,586 missing values generated)
(804 missing values generated)
(42 missing values generated)
(42 missing values generated)
(42 missing values generated)
(42 missing values generated)
(800 missing values generated)
(800 missing values generated)

. 
. 
.         
. foreach p in left right {
  2.         bysort llkk year (dist): egen rost_kom_`p'= sum (votes_`p')
  3.         gen sh_mv_`p'=votes_`p'/ rost_kom_`p'
  4. }

.         
. foreach p in b m c k f  g s v{
  2.         bysort llkk year (dist):  egen kom_votes_`p' =sum(rostm`p')
  3. * calculate share of group living in the district
.         gen sh_votes_`p' =rostm`p'/kom_votes_`p'
  4.         }       
(2,820 missing values generated)
(2 missing values generated)

.         
. 
. *** calculate concentration ***
.         
. foreach p in  left right {
  2.         *difference voters politicians
.                 gen diff_vald_`p'_vs= sh_vald_`p'-sh_mv_`p'
  3. }

.         
. gen diff_voters_bef= sh_votes-sh_non_votes

. 
. foreach var in votes_left votes_right {
  2. **calculate difference between share of group and share of population living in district
.         gen diff_`var'_bef =sh_`var'-((votes-`var')/(kom_votes-kom_`var'))
  3.         }

.         
. foreach p in b m c k f  g s v{
  2.         gen diff_votes_`p'_bef =sh_votes_`p'-((votes-rostm`p')/(kom_votes-kom_votes_`p'))
  3.         gen diff_votes_`p'_altbef =sh_votes_`p'-((bef-rostm`p')/(kom_bef-kom_votes_`p'))
  4.         }       
(2,820 missing values generated)
(2,820 missing values generated)
(2 missing values generated)
(2 missing values generated)

.         
.         
.         foreach var in highed em  child_7_15 retired highq own   {
  2. **calculate difference between share of group and share of population living in district
. if "`var'"=="own" loc t pop
  3. if "`var'"=="child_7_15"  loc t bef
  4. if "`var'"!="own" & "`var'"!="child_7_15" loc t adbef
  5.  gen diff_`var'_bef =sh_`var'-((`t'-`var')/(kom_`t'-kom_`var')) 
  6.         }
(800 missing values generated)

. 
. 
. 
.         
. foreach var of varlist area_single area_multi area_single_lag area_multi_lag vald- vald_left vald_maj- vald_min votes_maj votes_min
>  b_area_multi b_area_single   b_multi b_single {
  2. **calculate difference between share of group and share of population living in district
. gen diff_`var'_bef =sh_`var'-sh_adbef
  3.         }
(135 missing values generated)
(2,941 missing values generated)
(198 missing values generated)
(3,574 missing values generated)
(8,109 missing values generated)
(46 missing values generated)
(2,222 missing values generated)
(674 missing values generated)
(241 missing values generated)
(8,802 missing values generated)
(1,354 missing values generated)
(728 missing values generated)
(1,586 missing values generated)
(812 missing values generated)
(1,586 missing values generated)
(804 missing values generated)
(42 missing values generated)
(42 missing values generated)
(42 missing values generated)
(42 missing values generated)

.         
.         
. 
. *** calculate share relative to of  population in district      ***
. 
. foreach var in vald em highq highed own {
  2. if "`var'"=="own" loc t pop
  3. else loc t adbef
  4. gen `var'_sh= `var'/`t'
  5. }
(800 missing values generated)

.         
. 
. 
. g pop_dens=bef/land_area
(146 missing values generated)

. bys llkk year (dist): egen temp=mean(pop_dens)

. replace pop_dens=temp if mi(pop_dens)  // missing for 90 obs
(146 real changes made)

. drop temp

.         
. 
. gen floorarea_pc=  b_area_res/bef

. 
. foreach parti in b m c k f l g s v{
  2. gen vald_`parti'_sh= vald_`parti'/adbef
  3. gen votes_`parti'_sh=vsm_`parti'
  4. }
(5,668 missing values generated)

. 
. 
. *** calculate difference to municipality mean **
. 
. foreach var of varlist vald_b_sh- votes_v_sh  vald_sh- floorarea_pc ln_price_sqm_old  {
  2.         bysort llkk year (dist): egen `var'_munmean=mean(`var')
  3. gen `var'_mdiff=`var'-`var'_munmean
  4.         }
(5,668 missing values generated)
(5,668 missing values generated)
(800 missing values generated)
(19 missing values generated)
(1,139 missing values generated)

.         
. 
. 
. replace  diff_area_multi_lag_bef = 0 if  diff_area_multi_lag_bef==. 
(3,574 real changes made)

. replace  diff_area_single_lag_bef = 0 if  diff_area_single_lag_bef==.   
(198 real changes made)

. 
. gen diff_maj_min =sh_vald_maj -sh_vald_min 
(1,642 missing values generated)

. gen diffvs_maj_min =sh_votes_maj -sh_votes_min 
(1,634 missing values generated)

. 
. 
. 
. *** define close elections ***
. gen abs_diff_maj_min = abs( diff_maj_min)
(1,642 missing values generated)

. bysort year llkk (dist): egen sum_abs_diff_maj_min=sum(abs_diff_maj_min)

. bysort year llkk (dist): egen mean_abs_diff_maj_min=mean(abs_diff_maj_min)
(1,642 missing values generated)

. 
. bysort llkk year (dist): egen dist_count=count(dist)

.  gen abddiff_vald_left_right=abs( sh_vald_left  -sh_vald_right)

.  gen diff_vald_left_right= sh_vald_left  -sh_vald_right

.         
.         
. gen w_dist_count=1/ dist_count

. gen f_dist_count=int(w_dist_count*10000)

. gen close = (abs(dist_h_simp) <.05| abs(dist_v_simp) <.05) & dist_count!=1

. gen close_b = (abs(dist_h_simp) <.05 & abs(dist_v_simp) <.05) & dist_count!=1

. gen vclose = (abs(dist_h_simp) <.025| abs(dist_v_simp) <.025)  & dist_count!=1

. gen block_ch= block_rule<3 if block_rule!=. & dist_count!=1
(21 missing values generated)

. gen cl_bl=close==1 & block_ch==1

. gen bl= block_ch==1

. replace all=dist_count!=1
(17,427 real changes made)

. fasterxtile majvs_4q =diffvs_maj_min, nq(4) by( llkk year)

. fasterxtile majvs_10q =diffvs_maj_min, nq(10) by( llkk year)

. 
. *above below median size
. sum kom_adbef [aw=w_dist_count], d

                          kom_adbef
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2484           1963
 5%         4144           1995
10%       5175.5           2063       Obs              17,427
25%         7718           2181       Sum of wgt.         870

50%      11888.5                      Mean           24452.12
                        Largest       Std. dev.      47990.19
75%        24941         659838
90%        49351         659838       Variance       2.30e+09
95%        73778         659838       Skewness       8.706705
99%       206768         659838       Kurtosis       98.55176

. gen ab_med = kom_adbef> r(p50) if kom_adbef!=.

. gen bel_med = kom_adbef<= r(p50) if kom_adbef!=.

. gen ab_med_cl_bl= cl_bl==1 & ab_med==1

. gen bel_med_cl_bl= cl_bl==1 & bel_med==1

. drop if dist==9999
(0 observations deleted)

. 
. 
. *standardize variables
. foreach var of varlist diff_em_bef diff_own_bef  diff_highed_bef diff_highq_bef vald_b_sh_mdiff- votes_v_sh_mdiff diff_voters_bef  
> ln_price_sqm_old_mdiff ///
>  diff_vald_first_bef  diff_vald_left_vs  diff_vald_right_vs diff_vald_right_bef  diff_vald_left_bef   ///
>  floorarea_pc_mdiff  diff_vald_bef  diff_maj_min  diff_vald_left_right ///
>         diff_b_area_multi diff_b_area_single pop_dens_mdiff   diff_retired_bef diff_child_7_15_bef  diff_area_single_lag_bef  diff_
> area_multi_lag_bef  ///
>             {
  2.           sum `var' [aweight=w_dist_count]  if year==2002
  3.           g std_`var'=  (`var' - r(mean))/ r(sd)  if year==2002
  4.                   sum `var' [aweight=w_dist_count] if year==2006
  5.           replace std_`var'=  (`var' - r(mean))/ r(sd) if year==2006
  6.                   sum `var' [aweight=w_dist_count] if year==2010
  7.           replace std_`var'=  (`var' - r(mean))/ r(sd) if year==2010
  8. }

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
 diff_em_bef |   5,976         290    1.96e-19   .0843234  -.4806992   .2406059
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
 diff_em_bef |   5,783         290    8.43e-20   .0788377  -.4597426   .2153253
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
 diff_em_bef |   5,668         290   -2.94e-19   .0840352  -.4291608   .2407213
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_own_bef |   5,714  287.360764   -5.89e-19   .0809291  -.4360523   .3948314
(11,713 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_own_bef |   5,531  287.839116   -2.74e-19   .0833784  -.4775772   .4155739
(5,531 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_own_bef |   5,382  287.832609   -1.71e-19   .0847649  -.4474439   .3968673
(5,382 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highe~f |   5,976         290    1.57e-19    .027839  -.1159546   .1531815
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highe~f |   5,783         290   -3.22e-19   .0282365  -.1167701   .1482313
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highe~f |   5,668         290   -5.56e-20   .0297827  -.1527732   .1418119
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highq~f |   5,976         290    4.24e-19   .0265248  -.1026933   .1241665
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highq~f |   5,783         290   -1.92e-19   .0263006   -.115625   .1312745
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_highq~f |   5,668         290   -2.01e-20   .0301128  -.1671392   .1264224
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_b_sh_~f |   5,976         290   -6.43e-23   .0001354  -.0003606   .0032452
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_b_sh_~f |   5,783         290   -1.27e-21   .0002699  -.0006673   .0034314
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_b_sh_~f |   5,668         290    4.96e-23   .0003917  -.0008362   .0043192
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~n |   5,976         290    .0052047   .0123689          0   .0925496
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~n |   5,783         290    .0264214   .0270931          0   .2267825
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~n |   5,668         290    .0481415   .0335132   .0037565   .1938609
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~f |   5,976         290    8.13e-20   .0049482  -.0540251   .0741086
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~f |   5,783         290   -1.52e-19   .0110498  -.0961703   .1538829
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_b_sh~f |   5,668         290    1.66e-19   .0158393  -.0986638   .2400539
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~n |   5,976         290    .0005252   .0004815          0    .005332
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~n |   5,783         290    .0006445   .0004705          0   .0045113
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~n |   5,668         290    .0006908   .0004975          0   .0050942
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~f |   5,976         290   -7.42e-22   .0007767    -.00307    .006919
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~f |   5,783         290    4.40e-21   .0008347  -.0020939   .0056788
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_m_sh_~f |   5,668         290   -2.34e-21    .000822  -.0020032    .006733
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~n |   5,976         290    .1432595   .0781207   .0005403   .6578796
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~n |   5,783         290    .1935674   .0987345   .0042017   .6670343
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~n |   5,668         290    .2141292    .095619   .0048279   .5178833
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~f |   5,976         290   -2.21e-18   .0462558  -.2276649   .3935515
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~f |   5,783         290   -3.60e-20   .0547586  -.3124841   .4363757
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_m_sh~f |   5,668         290   -1.44e-19   .0573356  -.3026249    .456505
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~n |   5,976         290    .0007181   .0008715          0   .0090756
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~n |   5,783         290     .000692   .0007775          0   .0069728
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~n |   5,668         290    .0005518   .0006525          0   .0047206
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~f |   5,976         290    2.96e-21   .0010864  -.0090756   .0114519
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~f |   5,783         290    6.11e-21   .0010542  -.0058751   .0106365
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_c_sh_~f |   5,668         290   -5.83e-21   .0008005  -.0047206   .0092459
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~n |   5,976         290    .1433636   .0965083   .0052482   .5233043
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~n |   5,783         290    .1450903   .0929481   .0076743   .4698117
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~n |   5,668         290    .1214458   .0815759   .0066831   .4110235
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~f |   5,976         290   -1.40e-18   .0769198  -.2177567   .4837406
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~f |   5,783         290    2.93e-19   .0737308   -.250293   .3776946
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_c_sh~f |   5,668         290    1.48e-18   .0612804  -.2096493   .4733319
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~n |   5,976         290     .000295   .0003152          0    .002439
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~n |   5,783         290    .0002462   .0003107          0   .0023898
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~n |   5,668         290    .0001783   .0002822          0   .0029602
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~f |   5,976         290   -3.51e-22   .0006475   -.002439   .0084724
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~f |   5,783         290    1.72e-21   .0005624  -.0023898   .0096006
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_k_sh_~f |   5,668         290   -7.72e-22   .0003946  -.0019912   .0043736
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~n |   5,976         290    .0729021   .0404104   .0011762   .2671761
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~n |   5,783         290    .0619024   .0449204   .0016849   .4303234
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~n |   5,668         290    .0472715   .0420919          0   .4454725
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~f |   5,976         290   -1.07e-18   .0275499  -.1355691   .4613236
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~f |   5,783         290   -6.99e-19    .024482  -.1654808   .4372275
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_k_sh~f |   5,668         290    3.30e-20   .0216197  -.1233393   .4249333
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~n |   5,976         290    .0002929   .0002238          0   .0014542
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~n |   5,783         290    .0002398   .0002558          0   .0020331
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~n |   5,668         290    .0002387   .0002856          0    .002768
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~f |   5,976         290    1.05e-21   .0005423  -.0012187   .0037078
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~f |   5,783         290   -4.91e-22   .0004708  -.0014357   .0039249
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_f_sh_~f |   5,668         290   -1.23e-22   .0004666  -.0018908   .0043863
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~n |   5,976         290    .0855364   .0432804   .0069547   .2501621
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~n |   5,783         290    .0654482   .0355409   .0008799   .2226444
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~n |   5,668         290    .0669431   .0421258   .0029965   .3156081
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~f |   5,976         290   -1.68e-19   .0317898  -.1460051   .3634098
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~f |   5,783         290    2.27e-19   .0269784   -.156392   .3207112
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_f_sh~f |   5,668         290    3.45e-19   .0267965  -.2135034   .3570425
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~n |   5,976         290    .0002038   .0005938          0   .0073824
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~n |   5,783         290     .000234   .0006396          0   .0071983
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~n |   5,668         290    .0001886   .0005077          0   .0052567
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~f |   5,976         290    1.73e-21   .0005452  -.0051797   .0073822
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~f |   5,783         290   -6.27e-21   .0005678  -.0051983   .0060911
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_l_sh_~f |   5,668         290    2.66e-21   .0004444  -.0036719   .0037078
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~n |   5,976         290    .0703347   .0691648   .0070367   .4708952
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~n |   5,783         290    .0553957   .0762313    .000768   .4589368
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~n |       0           0
(0 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~f |   5,976         290   -1.07e-18   .0308162  -.1899123   .4916716
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~f |   5,783         290    9.83e-19   .0335402  -.2084127   .3782815
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_l_sh~f |       0           0
(0 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~n |   5,976         290    .0001043   .0001349          0   .0014778
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~n |   5,783         290    .0000897   .0000895          0    .000668
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~n |   5,668         290    .0001451   .0001315          0   .0013734
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~f |   5,976         290   -5.82e-22   .0003613  -.0014778   .0042364
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~f |   5,783         290   -7.62e-22   .0003028   -.000668   .0046296
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_g_sh_~f |   5,668         290    1.29e-22   .0003626  -.0013734   .0033214
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~n |   5,976         290    .0329577   .0281712   .0003723   .4133117
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~n |   5,783         290    .0322558   .0186389   .0003397   .1049437
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~n |   5,668         290    .0478338   .0247858   .0025105   .1637095
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~f |   5,976         290   -2.07e-19   .0138891  -.1883674   .2676525
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~f |   5,783         290    4.62e-19   .0144198  -.0710286   .2496771
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_g_sh~f |   5,668         290   -6.44e-19   .0174491   -.100606   .2214819
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~n |   5,976         290    .0015002   .0010811   .0000581    .008485
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~n |   5,783         290    .0014116   .0010332   .0000446   .0054335
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~n |   5,668         290    .0013743   .0011079   .0000399    .006584
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~f |   5,976         290   -6.35e-21   .0013429  -.0048552    .013066
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~f |   5,783         290   -1.16e-20    .001174  -.0039206    .006005
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_s_sh_~f |   5,668         290   -9.39e-21   .0011019   -.003962   .0059952
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~n |   5,976         290    .3693046   .0799554   .1002837   .5531525
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~n |   5,783         290    .3600401   .0899153   .0817586   .6072285
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~n |   5,668         290    .3519969   .0965876   .0679709   .5932841
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~f |   5,976         290   -2.82e-18    .086575  -.3214613   .4186822
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~f |   5,783         290    4.64e-19   .0854139  -.3006873   .4371349
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_s_sh~f |   5,668         290   -1.81e-18   .0817794  -.2844135   .5408823
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~n |   5,976         290    .0003083     .00036          0   .0027854
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~n |   5,783         290    .0002437   .0003822          0   .0034816
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~n |   5,668         290    .0002238    .000383          0    .003713
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~f |   5,976         290    2.35e-21   .0006603  -.0021692   .0070901
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~f |   5,783         290   -6.96e-22   .0005174  -.0019783   .0054084
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
vald_v_sh_~f |   5,668         290   -9.09e-22   .0004575   -.002235   .0044643
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~n |   5,976         290    .0771367    .053039    .005141   .5309227
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~n |   5,783         290    .0598787   .0512658   .0013254   .5836761
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~n |   5,668         290    .0549706   .0507944   .0032592   .5583046
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~f |   5,976         290    1.10e-18   .0271678  -.1592887   .3304162
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~f |   5,783         290   -1.10e-19   .0210133  -.1518892   .1715255
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
votes_v_sh~f |   5,668         290    1.27e-18    .019666  -.2676978   .1610071
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_voter~f |   5,976         290    3.71e-19   .0256016   -.138977    .099005
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_voter~f |   5,783         290    6.90e-19   .0243255  -.1251159   .0877002
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_voter~f |   5,668         290    3.20e-19   .0278694  -.1800793   .1531747
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
ln_price_s~f |   5,476  267.063544    2.95e-17   .3511142  -2.914133   1.839183
(11,951 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
ln_price_s~f |   5,473  282.800674    8.41e-18   .3219359  -2.802698   1.379183
(5,473 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
ln_price_s~f |   5,339  284.292454   -6.58e-17   .3112417    -2.8197   1.624927
(5,339 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_~st_bef |   5,976         290   -1.25e-18   .0775226   -.288993   .4287104
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_~st_bef |   5,783         290   -9.12e-19   .0827822  -.2959808   .4378665
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_~st_bef |   5,668         290   -7.54e-19   .0848643  -.2876712   .5213345
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ft_vs |   5,976         290   -1.24e-18   .0652301  -.2393422   .3670664
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ft_vs |   5,783         290   -8.05e-19   .0728475  -.2479741   .3784878
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ft_vs |   5,668         290   -1.63e-18   .0753482  -.2636894   .5490261
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ht_vs |   5,976         290   -1.32e-18   .0696832  -.3298539   .3457136
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ht_vs |   5,783         290   -1.38e-18   .0764643  -.3116012   .4707872
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~ht_vs |   5,668         290   -1.36e-18   .0778081  -.3149924   .4363431
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
~d_right_bef |   5,976         290   -1.16e-18   .0791427  -.3387097   .3987363
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_vald_.. |   5,783         290   -1.28e-18   .0859081  -.3451327   .5107832
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_vald_.. |   5,668         290   -1.43e-18   .0880328  -.4517747    .470868
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
d~d_left_bef |   5,976         290   -1.17e-18   .0687972  -.2674969   .3899509
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
d~d_left_bef |   5,783         290   -1.14e-18   .0769542  -.2746218   .3917094
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
d~d_left_bef |   5,668         290   -1.14e-18   .0787814  -.2833676    .549653
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
floorarea_~f |   5,976         290   -2.29e-16    18.6455  -71.29446   748.6535
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
floorarea_~f |   5,783         290    8.68e-17   19.15883  -72.06707   773.5025
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
floorarea_~f |   5,668         290    6.16e-17   21.24016  -78.24662   855.9502
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~d_bef |   5,976         290   -7.55e-19    .047837  -.2505998    .194963
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~d_bef |   5,783         290   -1.06e-18   .0508597  -.1845962   .2227522
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_v~d_bef |   5,668         290   -5.99e-19   .0510972   -.190897   .2568118
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_maj_min |   5,611         270    2.36e-19   .1080887      -.575   .8461538
(11,816 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_maj_min |   5,499         274    1.69e-19   .1163106  -.6666667       .775
(5,499 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_maj_min |   4,675         240   -3.36e-19   .1224839  -.6363636   .7511962
(4,675 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_vald_~t |   5,976         290   -1.82e-19   .1076439      -.575         .6
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_vald_~t |   5,783         290    1.13e-19   .1196925  -.6666667   .7368421
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_vald_~t |   5,668         290   -7.79e-21   .1212917        -.7         .7
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,957  289.425107    .0000508   .1102901  -.3127401   .6475078
(11,470 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,772  289.765219    .0000205   .1159753  -.4381875   .6470268
(5,772 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,656  289.750644     .000021   .1212466  -.4438289     .66034
(5,656 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,957  289.425107    .0000508   .0482859  -.1953818   .3448792
(11,470 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,772  289.765219    .0000205   .0509383  -.2068372   .3460099
(5,772 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_b_are.. |   5,656  289.750644     .000021   .0549539  -.2251393   .3365746
(5,656 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
pop_dens_m~f |   5,976         290    2.42e-19   .0419864  -.0922454   5.475513
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
pop_dens_m~f |   5,783         290   -5.47e-19   .0375649  -.0951723   4.060168
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
pop_dens_m~f |   5,668         290    1.10e-19   .0263595  -.0768071   2.858889
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_retir~f |   5,976         290   -5.86e-20   .0358233  -.1801138   .1538929
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_retir~f |   5,783         290   -1.90e-19   .0347582  -.1632064   .1772334
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_retir~f |   5,668         290   -5.98e-20   .0321757  -.1545778   .1541003
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_child~f |   5,976         290    1.70e-19   .0256276   -.133387     .12924
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_child~f |   5,783         290   -2.31e-19   .0262188  -.1522383   .1600395
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
diff_child~f |   5,668         290   -2.52e-20   .0276982  -.1327664   .1650068
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~e_lag_bef |   5,976         290   -4.90e-19   .1539531  -.6836228   .9555728
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~e_lag_bef |   5,783         290   -4.51e-20   .1330684  -.3797611   .9747006
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~e_lag_bef |   5,668         290    1.46e-19   .1511948  -.6129563   .9691532
(5,668 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~i_lag_bef |   5,976         290    4.65e-20   .1308151  -.3240803   .9855241
(11,451 missing values generated)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~i_lag_bef |   5,783         290   -5.80e-20   .1620477  -.3024793   .9723194
(5,783 real changes made)

    Variable |     Obs      Weight        Mean   Std. dev.       Min        Max
-------------+-----------------------------------------------------------------
di~i_lag_bef |   5,668         290    1.03e-19   .1837076   -.370346     .94298
(5,668 real changes made)

. 
. 
. sort llkk dist year

.  
. 
. 
. keep year llkk llkk_year dist diff_vald_right_vs diff_vald_left_vs diff_vald_bef diff_vald_first_bef diff_vald_left_bef diff_vald_r
> ight_bef ///
> diff_vald_m_bef diff_vald_c_bef diff_vald_k_bef diff_vald_f_bef diff_vald_g_bef diff_vald_s_bef diff_vald_v_bef ///
> diff_highq_bef diff_highed_bef diff_own_bef diff_em_bef  diff_retired_bef diff_child_7_15_bef diff_voters_bef diff_b_area_multi dif
> f_b_area_single  pop_dens_mdiff floorarea_pc_mdiff diff_area_single_lag_bef  diff_area_multi_lag_bef ///
> std_diff_highq_bef std_diff_highed_bef std_diff_own_bef std_diff_em_bef  std_diff_retired_bef std_diff_child_7_15_bef  std_diff_vot
> ers_bef std_diff_b_area_multi std_diff_b_area_single std_ln_price_sqm_old_mdiff ///
> std_pop_dens_mdiff std_floorarea_pc_mdiff  std_diff_area_single_lag_bef  std_diff_area_multi_lag_bef ///
> close ab_med ab_med_cl_bl ab_med_c  bel_med bel_med_cl_bl bel_med_c  bl cl_bl allamaj2 mmaj2 cmaj2 fpmaj2 kdmaj2 mpmaj2 smaj2 vmaj2
>  ///
> diff_votes_m_altbef diff_votes_c_altbef diff_votes_k_altbef diff_votes_f_altbef diff_votes_g_altbef diff_votes_s_altbef diff_votes_
> v_altbef diff_votes_b_altbef ///
> diff_area_multi_bef area_multi b_area_multi diff_b_area_multi diff_area_single_bef area_single b_area_single diff_b_area_single_bef
>  w_dist_count ///
> diff_votes_m_bef diff_votes_c_bef diff_votes_k_bef diff_votes_f_bef diff_votes_g_bef diff_votes_s_bef diff_votes_v_bef diff_maj_min
>  ///
> diffvs_maj_min majvs_4q majvs_10q dist_h_simp dist_v_simp ///
> diffalt_maj_min_vald_ab15sm diffalt_maj_min_vald_bel15sm diffalt_maj_min_vald_rel diffalt_maj_min_vald_norell diffalt_maj_min_vald_
> coll diffalt_maj_min_vald_nocoll  bef highq em highed own retired child_7_15 ///
> votes pop_dens floorarea_pc ln_price_sqm_old  vald_maj vald_min vanster_maj hoger_maj diff_vald_left_right adbef f_dist_count dist_
> count ///
> votes_m_sh_mdiff votes_c_sh_mdiff votes_k_sh_mdiff votes_f_sh_mdiff  votes_g_sh_mdiff votes_s_sh_mdiff votes_v_sh_mdiff ///
> vald_m_sh_mdiff vald_c_sh_mdiff vald_k_sh_mdiff vald_f_sh_mdiff  vald_g_sh_mdiff vald_s_sh_mdiff vald_v_sh_mdiff ///
>  em_sh_mdiff highq_sh_mdiff highed_sh_mdiff own_sh_mdiff vald_sh_mdiff diff_vald_maj_bef

. 
. 
. save "$dat\main.dta", replace
file \\micro.intra\Projekt\P0624$\P0624_Gem\Politisk Geografi\Data\main.dta saved

. 
. 
.           
. 
. log close
      name:  <unnamed>
       log:  \\micro.intra\Projekt\P0624$\P0624_Gem\Politisk Geografi\Results\log\merge.log
  log type:  text
 closed on:   2 Oct 2023, 16:50:38
-------------------------------------------------------------------------------------------------------------------------------------
